/ The Macintosh Demo: Business Productivity / The Macintosh Demo Applications CD - Business Productivity (Apple Computer)(1993).iso / Spreadsheets⁄Databases / SpreadBase® / Learning SpreadBase® / Formulas in SpreadBase / Formulas in SpreadBase.rsrc

< prev

next >

MacOS 8.1

Win98

DOS

browse contents

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 05 16 07 00 02 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 02 00 00 00 09 00 00 |........|........|
|00000020| 00 32 00 00 00 20 00 00 | 00 02 00 00 00 52 00 00 |.2... ..|.....R..|
|00000030| 12 48 53 52 53 50 53 52 | 50 4c 01 02 00 00 00 00 |.HSRSPSR|PL......|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 01 00 00 00 | 11 86 00 00 10 86 00 00 |........|........|
|00000060| 00 c2 00 02 00 03 01 01 | 00 00 00 00 00 10 00 08 |........|........|
|00000070| 00 00 00 00 00 06 00 00 | 00 42 01 76 02 1f 01 88 |........|.B.v....|
|00000080| 02 49 16 46 6f 72 6d 75 | 6c 61 73 20 69 6e 20 53 |.I.Formu|las in S|
|00000090| 70 72 65 61 64 42 61 73 | 65 20 02 00 00 00 53 52 |preadBas|e ....SR|
|000000a0| 53 50 00 00 53 52 53 50 | 53 52 50 4c 01 02 00 df |SP..SRSP|SRPL....|
|000000b0| 00 c3 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 a7 31 ba fc | 00 00 00 01 00 00 12 48 |.....1..|.......H|
|000000d0| 00 42 01 5c 02 1f 01 6e | 02 79 00 03 ff ff ff ff |.B.\...n|.y......|
|000000e0| ff ff 00 01 01 76 0b 50 | 61 75 73 65 2f 43 6f 6e |.....v.P|ause/Con|
|000000f0| 74 2e 1a 1a 00 00 07 b8 | 00 34 38 0e 00 00 e0 f8 |t.......|.48.....|
|00000100| 00 01 1f e8 40 80 20 04 | b6 00 00 03 01 01 00 00 |....@. .|........|
|00000110| 00 00 00 10 00 08 00 00 | 00 00 00 01 00 00 00 24 |........|.......$|
|00000120| 01 43 02 1b 01 54 02 7e | 00 02 02 41 ab 54 ea ff |.C...T.~|...A.T..|
|00000130| 00 01 01 76 12 8c 01 00 | 00 0a 00 00 00 00 00 00 |...v....|........|
|00000140| 00 01 01 72 00 08 00 00 | 00 09 31 30 61 20 6f 66 |...r....|..10a of|
|00000150| 20 32 00 00 00 78 00 03 | 00 00 00 48 00 48 00 00 | 2...x..|...H.H..|
|00000160| 00 00 02 da 02 28 ff e1 | ff e2 02 f9 02 46 03 47 |.....(..|.....F.G|
|00000170| 05 28 03 fc 00 02 00 00 | 00 48 00 48 00 00 00 00 |.(......|.H.H....|
|00000180| 02 da 02 28 00 01 00 00 | 00 64 00 00 00 01 00 01 |...(....|.d......|
|00000190| 01 01 00 00 00 01 27 0f | 00 01 00 01 00 00 00 00 |......'.|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 02 00 19 01 90 00 00 |........|........|
|000001b0| 00 00 00 40 00 00 00 00 | 00 00 00 00 00 01 00 00 |...@....|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 2a 00 0b 00 02 00 a6 | 00 21 01 69 02 61 00 00 |.*......|.!.i.a..|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|000001f0| 00 00 00 00 02 80 01 e0 | 02 00 00 00 00 00 02 04 |........|........|
|00000200| 4d a5 00 00 00 00 00 00 | 00 00 0a 50 31 20 46 6f |M.......|...P1 Fo|
|00000210| 6d 75 6c 61 73 5c 00 45 | 66 5c 00 00 00 00 00 00 |mulas\.E|f\......|
|00000220| 00 00 00 00 00 00 00 73 | b3 2e 00 72 00 00 00 01 |.......s|...r....|
|00000230| 00 00 00 00 00 00 00 00 | 01 41 00 00 01 00 00 00 |........|.A......|
|00000240| 00 00 00 01 02 00 00 00 | 00 00 00 c1 00 00 00 ff |........|........|
|00000250| ff 00 00 00 00 ff ff ff | 00 00 ff ff 00 00 00 00 |........|........|
|00000260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 41 4c |........|......AL|
|00000270| 52 54 7f ff ff ff fc 00 | 00 00 40 00 00 00 0c 00 |RT......|..@.....|
|00000280| 00 00 47 ff 6f ff 8c 00 | 00 00 47 ff 6f ff 8c 00 |..G.o...|..G.o...|
|00000290| 00 00 40 00 04 00 0c 00 | 00 00 7f ff ff ff fc 00 |..@.....|........|
|000002a0| 00 00 7f ff ff ff ff ff | ff f0 3f ff ff ff ff ff |........|..?.....|
|000002b0| ff e0 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 03 ff bd ff 5f f0 | 00 00 01 91 39 3f 5b f0 |......_.|....9?[.|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 01 ff ff f8 00 00 |........|........|
|000002e0| 00 00 01 ef fe 08 00 00 | 00 00 01 ff ff f8 00 00 |........|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 00 00 ff f7 ff ef 80 | 00 00 00 ce 36 f1 28 00 |........|....6.(.|
|00000310| 00 00 00 ff bf ef ff f8 | 00 00 00 fd 78 00 00 00 |........|....x...|
|00000320| 00 00 00 fd 7c 00 00 00 | 00 00 00 00 00 00 00 00 |....|...|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 01 ff ff f0 00 00 | 00 00 01 fd ff d0 00 00 |........|........|
|00000350| 00 00 01 ff ff f0 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000360| 00 00 00 00 00 00 00 00 | 03 ff 01 ff ff fe ff f7 |........|........|
|00000370| c7 ff 00 14 00 00 40 01 | 87 ff 01 ef ff ff 7f ff |......@.|........|
|00000380| 87 ff 01 ff f7 57 bf e7 | c7 ff 00 fb 57 d6 b3 f6 |.....W..|....W...|
|00000390| 46 fd 01 df ef ff ff e0 | 07 ff 00 f9 dd ad 00 00 |F.......|........|
|000003a0| 07 ff 01 ff ff bf 80 00 | 07 ff 00 00 00 00 00 00 |........|........|
|000003b0| 03 ff 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 00 00 00 00 00 00 | 00 a0 00 00 00 00 00 00 |........|........|
|00000400| 00 00 00 01 00 00 05 42 | 00 01 00 00 00 24 00 63 |.......B|.....$.c|
|00000410| 00 3a 00 7e 01 d6 00 02 | ff ff ff ff ff ff 00 04 |.:.~....|........|
|00000420| 01 33 00 03 01 00 00 0e | 00 00 00 00 00 00 00 00 |.3......|........|
|00000430| 00 a0 00 08 00 00 00 2e | 54 68 65 72 65 20 61 72 |........|There ar|
|00000440| 65 20 74 77 6f 20 74 79 | 70 65 73 20 6f 66 20 66 |e two ty|pes of f|
|00000450| 6f 72 6d 75 6c 61 73 20 | 69 6e 20 53 70 72 65 61 |ormulas |in Sprea|
|00000460| 64 42 61 73 65 3a 00 02 | 00 00 00 24 00 3e 00 0e |dBase:..|...$.>..|
|00000470| 00 40 02 56 00 03 00 00 | 00 00 00 00 00 02 01 5d |.@.V....|.......]|
|00000480| 00 3f 02 55 00 3f 00 0f | 00 0a 00 04 00 00 00 33 |.?.U.?..|.......3|
|00000490| 00 02 00 00 00 24 00 43 | 00 0d 00 47 02 57 00 03 |.....$.C|...G.W..|
|000004a0| 00 00 00 00 00 00 00 03 | 01 5d 00 45 02 55 00 45 |........|.].E.U.E|
|000004b0| 00 0f 00 0a 00 04 00 00 | 00 33 00 01 00 00 00 24 |........|.3.....$|
|000004c0| 00 05 00 0e 00 38 01 75 | 00 02 dd 6b 08 c2 06 a2 |.....8.u|...k....|
|000004d0| 00 02 01 0d 00 03 01 00 | 00 0e 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 02 5d 00 08 00 00 | 00 00 00 01 00 00 00 24 |...]....|.......$|
|000004f0| 00 08 00 12 00 34 01 71 | 00 02 ff ff ff ff ff ff |.....4.q|........|
|00000500| 00 02 01 62 00 03 01 00 | 00 0e 00 00 00 00 00 00 |...b....|........|
|00000510| 00 00 01 5d 00 08 00 00 | 00 00 00 01 00 00 00 24 |...]....|.......$|
|00000520| 00 14 00 1c 00 29 01 66 | 00 02 ff ff ff ff ff ff |.....).f|........|
|00000530| 00 04 01 62 00 14 01 00 | 00 18 00 00 00 00 00 00 |...b....|........|
|00000540| 00 01 00 5d 00 08 00 00 | 00 16 46 6f 72 6d 75 6c |...]....|..Formul|
|00000550| 61 73 20 69 6e 20 53 70 | 72 65 61 64 42 61 73 65 |as in Sp|readBase|
|00000560| 00 01 00 00 00 24 00 b4 | 00 4d 00 eb 01 e2 00 02 |.....$..|.M......|
|00000570| ff ff ff ff ff ff 00 02 | 01 62 00 03 01 00 00 0c |........|.b......|
|00000580| 00 00 00 00 00 00 00 00 | 00 5d 00 08 00 00 00 75 |........|.].....u|
|00000590| 53 70 72 65 61 64 73 68 | 65 65 74 2d 6c 69 6b 65 |Spreadsh|eet-like|
|000005a0| 20 63 65 6c 6c 2d 62 61 | 73 65 64 20 66 6f 72 6d | cell-ba|sed form|
|000005b0| 75 6c 61 73 20 73 75 63 | 68 20 61 73 20 22 3d 42 |ulas suc|h as "=B|
|000005c0| 34 2b 41 31 34 22 20 6f | 72 20 22 3d 53 55 4d 28 |4+A14" o|r "=SUM(|
|000005d0| 42 31 3a 42 35 29 22 20 | 61 72 65 20 62 61 73 65 |B1:B5)" |are base|
|000005e0| 64 20 6f 6e 20 63 6f 6f | 72 64 69 6e 61 74 65 20 |d on coo|rdinate |
|000005f0| 6c 6f 63 61 74 69 6f 6e | 73 20 69 6e 20 61 20 76 |location|s in a v|
|00000600| 69 65 77 2e 20 00 00 01 | 00 00 00 24 01 06 00 49 |iew. ...|...$...I|
|00000610| 01 20 01 16 00 02 ff ff | ff ff ff ff 00 02 01 62 |. ......|.......b|
|00000620| 00 03 01 00 00 0c 00 00 | 00 00 00 00 00 00 02 5d |........|.......]|
|00000630| 00 08 00 00 00 17 43 61 | 74 65 67 6f 72 79 2d 62 |......Ca|tegory-b|
|00000640| 61 73 65 64 20 46 6f 72 | 6d 75 6c 61 73 00 00 01 |ased For|mulas...|
|00000650| 00 00 00 24 00 83 00 4d | 00 9d 01 1a 00 02 ff ff |...$...M|........|
|00000660| ff ff ff ff 00 02 01 62 | 00 03 01 00 00 0c 00 00 |.......b|........|
|00000670| 00 00 00 00 00 00 02 5d | 00 08 00 00 00 13 43 65 |.......]|......Ce|
|00000680| 6c 6c 2d 62 61 73 65 64 | 20 46 6f 72 6d 75 6c 61 |ll-based| Formula|
|00000690| 73 00 00 01 00 00 00 24 | 01 35 00 4a 01 89 01 fe |s......$|.5.J....|
|000006a0| 00 02 ff ff ff ff ff ff | 00 02 01 62 00 03 01 00 |........|...b....|
|000006b0| 00 0c 00 00 00 00 00 00 | 00 00 00 5d 00 08 00 00 |........|...]....|
|000006c0| 01 05 43 61 74 65 67 6f | 72 79 2d 62 61 73 65 64 |..Catego|ry-based|
|000006d0| 20 66 6f 72 6d 75 6c 61 | 73 20 73 75 63 68 20 61 | formula|s such a|
|000006e0| 73 20 22 56 61 72 69 61 | 6e 63 65 3d 41 63 74 75 |s "Varia|nce=Actu|
|000006f0| 61 6c 2d 42 75 64 67 65 | 74 22 20 72 65 66 65 72 |al-Budge|t" refer|
|00000700| 20 74 6f 20 64 61 74 61 | 20 69 6e 20 6c 6f 67 69 | to data| in logi|
|00000710| 63 61 6c 20 67 72 6f 75 | 70 69 6e 67 73 2e 20 20 |cal grou|pings.  |
|00000720| 59 6f 75 20 63 61 6e 20 | 77 72 69 74 65 20 61 20 |You can |write a |
|00000730| 73 69 6e 67 6c 65 20 66 | 6f 72 6d 75 6c 61 20 74 |single f|ormula t|
|00000740| 68 61 74 20 77 69 6c 6c | 20 61 70 70 6c 79 20 74 |hat will| apply t|
|00000750| 6f 20 61 6e 20 65 6e 74 | 69 72 65 20 63 65 6c 6c |o an ent|ire cell|
|00000760| 20 63 61 74 65 67 6f 72 | 79 2e 20 20 52 65 76 69 | categor|y.  Revi|
|00000770| 65 77 20 74 68 65 20 22 | 53 70 6c 69 74 74 69 6e |ew the "|Splittin|
|00000780| 67 20 43 65 6c 6c 73 22 | 20 73 65 63 74 69 6f 6e |g Cells"| section|
|00000790| 20 6f 66 20 74 68 69 73 | 20 64 65 6d 6f 20 74 6f | of this| demo to|
|000007a0| 20 73 65 65 20 63 61 74 | 65 67 6f 72 79 2d 62 61 | see cat|egory-ba|
|000007b0| 73 65 64 20 66 6f 72 6d | 75 6c 61 73 20 69 6e 20 |sed form|ulas in |
|000007c0| 61 63 74 69 6f 6e 2e 00 | 00 03 00 00 00 14 01 53 |action..|.......S|
|000007d0| 02 1b 01 8f 02 7e 00 03 | 02 41 ab 54 ea ff 00 01 |.....~..|.A.T....|
|000007e0| 01 5d 00 06 00 00 00 42 | 01 5c 02 1f 01 6e 02 79 |.].....B|.\...n.y|
|000007f0| 00 03 ff ff ff ff ff ff | 00 01 01 1b 08 43 6f 6e |........|.....Con|
|00000800| 74 69 6e 75 65 6e 74 2e | 1a 1a 00 00 07 b8 00 34 |tinuent.|.......4|
|00000810| 38 0e 00 00 e0 f8 00 01 | 1f e8 40 80 20 04 00 00 |8.......|..@. ...|
|00000820| 00 03 01 01 00 00 00 00 | 00 10 00 08 00 00 00 00 |........|........|
|00000830| 00 06 00 00 00 42 01 76 | 02 4f 01 88 02 79 00 03 |.....B.v|.O...y..|
|00000840| ff ff ff ff ff ff 00 01 | 01 62 04 51 75 69 74 77 |........|.b.Quitw|
|00000850| 61 72 64 73 6e 81 1a 1a | 00 00 07 b8 00 34 38 0e |ardsn...|.....48.|
|00000860| 00 00 e0 f8 00 01 1f e8 | 40 80 20 04 00 02 00 03 |........|@. .....|
|00000870| 01 01 00 00 00 00 00 10 | 00 08 00 00 00 00 00 06 |........|........|
|00000880| 00 00 00 42 01 76 02 1f | 01 88 02 49 00 03 ff ff |...B.v..|...I....|
|00000890| ff ff ff ff 00 01 01 62 | 04 4d 65 6e 75 74 20 45 |.......b|.Menut E|
|000008a0| 6e 64 61 73 65 20 54 72 | 61 69 6e 69 6e 67 ec 40 |ndase Tr|aining.@|
|000008b0| 00 75 e1 02 00 37 e6 70 | 00 75 00 09 00 03 01 01 |.u...7.p|.u......|
|000008c0| 2f 06 00 00 00 10 00 08 | 00 00 00 0a 3a 46 72 6f |/.......|....:Fro|
|000008d0| 6e 74 20 45 6e 64 00 01 | 00 00 00 24 01 43 02 1b |nt End..|...$.C..|
|000008e0| 01 54 02 7e 00 02 02 41 | ab 54 ea ff 00 01 01 62 |.T.~...A|.T.....b|
|000008f0| 00 14 01 00 00 0a 00 00 | 00 00 00 00 00 01 01 5d |........|.......]|
|00000900| 00 08 00 00 00 06 31 20 | 6f 66 20 32 00 01 00 00 |......1 |of 2....|
|00000910| 00 24 01 31 02 1b 01 44 | 02 7e 00 02 02 41 ab 54 |.$.1...D|.~...A.T|
|00000920| ea ff 00 01 01 62 00 14 | 01 00 00 0a 00 00 00 00 |.....b..|........|
|00000930| 00 00 00 01 01 5d 00 08 | 00 00 00 08 46 6f 72 6d |.....]..|....Form|
|00000940| 75 6c 61 73 00 00 00 00 | 00 00 00 00 02 04 41 11 |ulas....|......A.|
|00000950| 00 00 00 00 00 00 00 00 | 0a 50 32 20 46 6f 6d 75 |........|.P2 Fomu|
|00000960| 6c 61 73 07 ff 00 00 00 | fc c0 00 20 84 00 00 00 |las.....|... ....|
|00000970| 00 00 01 e0 02 80 00 00 | 00 00 00 00 00 01 00 00 |........|........|
|00000980| 00 00 00 00 00 00 01 00 | 00 00 01 00 00 00 00 00 |........|........|
|00000990| 00 01 27 04 00 00 00 00 | 00 c1 13 43 65 6c 6c 2d |..'.....|...Cell-|
|000009a0| 62 61 73 65 64 20 46 6f | 72 6d 75 6c 61 73 15 6e |based Fo|rmulas.n|
|000009b0| 00 00 01 00 00 05 00 76 | da e8 00 00 00 00 00 00 |.......v|........|
|000009c0| 00 00 00 00 00 00 00 00 | 70 00 08 00 00 00 00 00 |........|p.......|
|000009d0| 7f ef af fe 00 00 00 00 | 7f ef eb fe 00 00 00 00 |........|........|
|000009e0| 78 00 00 00 00 00 00 00 | 7f ff ff ff ff ff ff f0 |x.......|........|
|000009f0| 3f ff ff ff ff ff ff f0 | 00 00 00 00 00 00 00 00 |?.......|........|
|00000a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a10| 03 ff ff ff ff bf e0 00 | 00 09 00 00 00 20 00 00 |........|..... ..|
|00000a20| 03 ff ff fc 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a30| 00 00 00 00 00 00 00 00 | 07 ff ff e0 00 00 00 00 |........|........|
|00000a40| 07 ff c0 20 00 00 00 00 | 03 ff ff e0 00 00 00 00 |... ....|........|
|00000a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a60| 03 ff ff eb 7f f0 00 00 | 02 08 00 80 40 00 00 00 |........|....@...|
|00000a70| 03 ff ff ff fe fc 00 00 | 03 77 fd f8 00 00 00 00 |........|.w......|
|00000a80| 01 07 2c 48 00 00 00 00 | 00 00 00 00 00 00 00 00 |..,H....|........|
|00000a90| 00 00 00 00 00 00 00 00 | 03 ff ff e0 00 00 00 00 |........|........|
|00000aa0| 07 ff f8 20 00 00 00 00 | 04 00 00 20 00 00 00 00 |... ....|... ....|
|00000ab0| 03 ff ff e0 00 00 03 ff | 00 00 00 00 00 00 07 ff |........|........|
|00000ac0| 03 ff ff ff ff ff 87 ff | 03 7e fe ff 7d ee 07 ff |........|.~..}...|
|00000ad0| 03 5f fe fb 6d 6f 07 ff | 01 ff 7f ff fe f5 87 fd |._..mo..|........|
|00000ae0| 02 04 00 81 90 00 07 ff | 03 df ff ff ff f8 07 ff |........|........|
|00000af0| 03 f0 00 00 00 00 07 ff | 00 40 00 00 00 00 03 ff |........|.@......|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b40| 00 00 00 00 00 00 00 fd | 00 00 00 00 00 00 00 00 |........|........|
|00000b50| ff 01 00 00 06 1e 00 01 | 00 00 00 24 00 61 00 3a |........|...$.a.:|
|00000b60| 00 89 01 f9 00 02 ff ff | ff ff ff ff 00 04 01 00 |........|........|
|00000b70| 00 03 01 00 00 0e 00 00 | 00 00 00 00 00 00 00 45 |........|.......E|
|00000b80| 00 08 00 00 00 51 46 6f | 72 6d 75 6c 61 73 20 63 |.....QFo|rmulas c|
|00000b90| 61 6e 20 65 69 74 68 65 | 72 20 62 65 20 63 72 65 |an eithe|r be cre|
|00000ba0| 61 74 65 64 20 6d 61 6e | 75 61 6c 6c 79 20 6f 72 |ated man|ually or|
|00000bb0| 20 67 65 6e 65 72 61 74 | 65 64 20 61 75 74 6f 6d | generat|ed autom|
|00000bc0| 61 74 69 63 61 6c 6c 79 | 20 62 79 20 53 70 72 65 |atically| by Spre|
|00000bd0| 61 64 42 61 73 65 3a 00 | 00 01 00 00 00 24 00 c6 |adBase:.|.....$..|
|00000be0| 00 3b 00 fd 01 d0 00 02 | ff ff ff ff ff ff 00 02 |.;......|........|
|00000bf0| 01 47 00 03 01 00 00 0c | 00 00 00 00 00 00 00 00 |.G......|........|
|00000c00| 00 42 00 08 00 00 00 8b | 4d 61 6e 75 61 6c 20 66 |.B......|Manual f|
|00000c10| 6f 72 6d 75 6c 61 73 20 | 66 6f 6c 6c 6f 77 20 73 |ormulas |follow s|
|00000c20| 70 72 65 61 64 73 68 65 | 65 74 2d 6c 69 6b 65 20 |preadshe|et-like |
|00000c30| 70 72 6f 63 65 64 75 72 | 65 73 2e 20 20 4d 6f 76 |procedur|es.  Mov|
|00000c40| 65 20 74 6f 20 74 68 65 | 20 6e 65 78 74 20 73 65 |e to the| next se|
|00000c50| 63 74 69 6f 6e 20 22 43 | 65 6c 6c 2d 62 61 73 65 |ction "C|ell-base|
|00000c60| 64 20 46 6f 72 6d 75 6c | 61 73 22 20 74 6f 20 66 |d Formul|as" to f|
|00000c70| 69 6e 64 20 6f 75 74 20 | 6d 6f 72 65 20 61 62 6f |ind out |more abo|
|00000c80| 75 74 20 6d 61 6e 75 61 | 6c 20 66 6f 72 6d 75 6c |ut manua|l formul|
|00000c90| 61 73 2e 00 00 01 00 00 | 00 24 01 13 00 3b 01 2d |as......|.$...;.-|
|00000ca0| 01 08 00 02 ff ff ff ff | ff ff 00 02 01 47 00 03 |........|.....G..|
|00000cb0| 01 00 00 0c 00 00 00 00 | 00 00 00 00 02 42 00 08 |........|.....B..|
|00000cc0| 00 00 00 12 41 75 74 6f | 6d 61 74 69 63 20 46 6f |....Auto|matic Fo|
|00000cd0| 72 6d 75 6c 61 73 00 01 | 00 00 00 24 00 96 00 3b |rmulas..|...$...;|
|00000ce0| 00 b0 01 08 00 02 ff ff | ff ff ff ff 00 02 01 47 |........|.......G|
|00000cf0| 00 03 01 00 00 0c 00 00 | 00 00 00 00 00 00 02 42 |........|.......B|
|00000d00| 00 08 00 00 00 0f 4d 61 | 6e 75 61 6c 20 46 6f 72 |......Ma|nual For|
|00000d10| 6d 75 6c 61 73 00 00 01 | 00 00 00 24 01 3c 00 3a |mulas...|...$.<.:|
|00000d20| 01 90 01 ee 00 02 ff ff | ff ff ff ff 00 02 01 47 |........|.......G|
|00000d30| 00 03 01 00 00 0c 00 00 | 00 00 00 00 00 00 00 42 |........|.......B|
|00000d40| 00 08 00 00 00 ee 59 6f | 75 27 6c 6c 20 73 65 65 |......Yo|u'll see|
|00000d50| 20 61 6e 20 65 78 61 6d | 70 6c 65 20 6f 66 20 61 | an exam|ple of a|
|00000d60| 20 4d 61 74 72 69 78 20 | 76 69 65 77 20 61 75 74 | Matrix |view aut|
|00000d70| 6f 6d 61 74 69 63 20 66 | 6f 72 6d 75 6c 61 20 69 |omatic f|ormula i|
|00000d80| 6e 20 74 68 65 20 22 43 | 72 65 61 74 69 6e 67 20 |n the "C|reating |
|00000d90| 41 75 74 6f 6d 61 74 69 | 63 20 53 75 6d 6d 61 72 |Automati|c Summar|
|00000da0| 69 65 73 22 20 73 65 63 | 74 69 6f 6e 20 6f 66 20 |ies" sec|tion of |
|00000db0| 74 68 69 73 20 64 65 6d | 6f 2e 20 20 52 65 66 65 |this dem|o.  Refe|
|00000dc0| 72 20 74 6f 20 74 68 65 | 20 73 6f 72 74 69 6e 67 |r to the| sorting|
|00000dd0| 20 61 6e 64 20 73 75 6d | 6d 61 72 69 7a 69 6e 67 | and sum|marizing|
|00000de0| 20 73 65 67 6d 65 6e 74 | 20 69 6e 20 74 68 65 20 | segment| in the |
|00000df0| 22 54 61 62 6c 65 20 56 | 69 65 77 22 20 73 65 63 |"Table V|iew" sec|
|00000e00| 74 69 6f 6e 20 74 6f 20 | 73 65 65 20 61 6e 6f 74 |tion to |see anot|
|00000e10| 68 65 72 20 65 78 61 6d | 70 6c 65 20 6f 66 20 61 |her exam|ple of a|
|00000e20| 6e 20 61 75 74 6f 6d 61 | 74 69 63 20 66 6f 72 6d |n automa|tic form|
|00000e30| 75 6c 61 2e 00 02 00 00 | 00 24 00 34 00 0f 00 36 |ula.....|.$.4...6|
|00000e40| 02 57 00 03 00 00 00 00 | 00 00 00 02 01 42 00 35 |.W......|.....B.5|
|00000e50| 02 56 00 35 00 10 00 0a | 00 04 00 00 00 18 00 02 |.V.5....|........|
|00000e60| 00 00 00 24 00 39 00 0e | 00 3d 02 58 00 03 00 00 |...$.9..|.=.X....|
|00000e70| 00 00 00 00 00 03 01 42 | 00 3b 02 56 00 3b 00 10 |.......B|.;.V.;..|
|00000e80| 00 0a 00 04 00 00 00 18 | 00 01 00 00 00 24 00 10 |........|.....$..|
|00000e90| 00 35 00 2b 02 32 00 02 | ff ff ff ff ff ff 00 04 |.5.+.2..|........|
|00000ea0| 01 0e 00 14 01 00 00 18 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 42 00 08 00 00 00 13 | 4d 6f 72 65 20 41 62 6f |.B......|More Abo|
|00000ec0| 75 74 20 46 6f 72 6d 75 | 6c 61 73 00 00 01 00 00 |ut Formu|las.....|
|00000ed0| 00 24 00 0e 00 0f 00 29 | 00 2f 00 02 dd 6b 08 c2 |.$.....)|./...k..|
|00000ee0| 06 a2 00 02 01 47 00 03 | 01 00 00 0e 00 00 00 00 |.....G..|........|
|00000ef0| 00 00 00 00 02 42 00 08 | 00 00 00 00 00 03 00 00 |.....B..|........|
|00000f00| 00 14 01 53 02 1b 01 8f | 02 7e 00 03 02 41 ab 54 |...S....|.~...A.T|
|00000f10| ea ff 00 01 01 42 00 06 | 00 00 00 42 01 76 02 4f |.....B..|...B.v.O|
|00000f20| 01 88 02 79 00 03 ff ff | ff ff ff ff 00 01 01 1b |...y....|........|
|00000f30| 04 51 75 69 74 77 61 72 | 64 73 6e 81 1a 1a 00 00 |.Quitwar|dsn.....|
|00000f40| 07 b8 00 34 38 0e 00 00 | e0 f8 00 01 1f e8 40 80 |...48...|......@.|
|00000f50| 20 04 00 02 00 03 01 01 | 00 00 00 00 00 10 00 08 | .......|........|
|00000f60| 00 00 00 00 00 06 00 00 | 00 42 01 76 02 1f 01 88 |........|.B.v....|
|00000f70| 02 49 00 03 ff ff ff ff | ff ff 00 01 01 47 04 4d |.I......|.....G.M|
|00000f80| 65 6e 75 74 20 45 6e 64 | 61 73 65 20 54 72 61 69 |enut End|ase Trai|
|00000f90| 6e 69 6e 67 ec 40 00 75 | e1 02 00 37 e6 70 00 75 |ning.@.u|...7.p.u|
|00000fa0| 00 09 00 03 01 01 2f 06 | 00 00 00 10 00 08 00 00 |....../.|........|
|00000fb0| 00 0a 3a 46 72 6f 6e 74 | 20 45 6e 64 00 01 00 00 |..:Front| End....|
|00000fc0| 00 24 01 43 02 1b 01 54 | 02 7e 00 02 02 41 ab 54 |.$.C...T|.~...A.T|
|00000fd0| ea ff 00 01 01 47 00 14 | 01 00 00 0a 00 00 00 00 |.....G..|........|
|00000fe0| 00 00 00 01 01 42 00 08 | 00 00 00 06 32 20 6f 66 |.....B..|....2 of|
|00000ff0| 20 32 00 06 00 00 00 42 | 01 5c 02 4f 01 6e 02 79 | 2.....B|.\.O.n.y|
|00001000| 00 03 ff ff ff ff ff ff | 00 01 01 47 08 63 6f 6e |........|...G.con|
|00001010| 74 69 6e 75 65 73 6e 81 | 1a 1a 00 00 07 b8 00 34 |tinuesn.|.......4|
|00001020| 38 0e 00 00 e0 f8 00 01 | 1f e8 40 80 20 04 00 00 |8.......|..@. ...|
|00001030| 00 03 00 01 00 00 00 00 | 00 10 00 08 00 00 00 00 |........|........|
|00001040| 00 02 00 00 00 24 01 59 | 02 52 01 71 02 7a 00 03 |.....$.Y|.R.q.z..|
|00001050| 00 00 00 00 00 00 00 02 | 01 42 01 65 02 6e 01 65 |........|.B.e.n.e|
|00001060| 02 5e 00 0a 00 04 00 01 | 01 18 00 02 00 00 00 24 |.^......|.......$|
|00001070| 01 63 02 59 01 67 02 65 | 00 03 00 00 00 00 00 00 |.c.Y.g.e|........|
|00001080| 00 03 01 07 01 65 02 63 | 01 65 02 5b 00 0a 00 04 |.....e.c|.e.[....|
|00001090| 00 00 01 44 00 06 00 00 | 00 42 01 5c 02 1f 01 6e |...D....|.B.\...n|
|000010a0| 02 49 00 03 ff ff ff ff | ff ff 00 01 01 59 04 62 |.I......|.....Y.b|
|000010b0| 61 63 6b 74 20 45 6e 64 | 61 73 65 20 54 72 61 69 |ackt End|ase Trai|
|000010c0| 6e 69 6e 67 ec 40 00 75 | e1 02 00 37 e6 70 00 75 |ning.@.u|...7.p.u|
|000010d0| 40 0c 9b 03 00 01 4d a5 | 00 00 00 10 00 08 00 00 |@.....M.|........|
|000010e0| 00 00 00 02 00 00 00 24 | 01 59 02 1e 01 71 02 48 |.......$|.Y...q.H|
|000010f0| 00 03 00 00 00 00 00 00 | 00 02 01 42 01 65 02 3c |........|...B.e.<|
|00001100| 01 65 02 2a 00 0a 00 04 | 01 00 01 18 00 02 00 00 |.e.*....|........|
|00001110| 00 24 01 63 02 32 01 67 | 02 3e 00 03 00 00 00 00 |.$.c.2.g|.>......|
|00001120| 00 00 00 03 01 42 01 65 | 02 3c 01 65 02 34 00 0a |.....B.e|.<.e.4..|
|00001130| 00 04 00 00 01 18 00 01 | 00 00 00 24 01 31 02 1b |........|...$.1..|
|00001140| 01 44 02 7e 00 02 02 41 | ab 54 ea ff 00 01 01 32 |.D.~...A|.T.....2|
|00001150| 00 14 01 00 00 0a 00 00 | 00 00 00 00 00 01 01 42 |........|.......B|
|00001160| 00 08 00 00 00 08 46 6f | 72 6d 75 6c 61 73 00 00 |......Fo|rmulas..|
|00001170| 00 00 00 00 00 00 00 14 | 3a 43 65 6c 6c 2d 62 61 |........|:Cell-ba|
|00001180| 73 65 64 20 46 6f 72 6d | 75 6c 61 73 00 00 00 04 |sed Form|ulas....|
|00001190| 4d a5 41 11 00 00 00 40 | 00 03 00 03 06 47 65 6e |M.A....@|.....Gen|
|000011a0| 65 76 61 00 00 00 00 00 | 07 43 68 69 63 61 67 6f |eva.....|.Chicago|
|000011b0| 00 14 00 14 05 54 69 6d | 65 73 00 16 00 16 07 43 |.....Tim|es.....C|
|000011c0| 6f 75 72 69 65 72 37 47 | 00 0d 0d 5a 61 70 66 20 |ourier7G|...Zapf |
|000011d0| 44 69 6e 67 62 61 74 73 | 00 00 01 00 00 00 11 86 |Dingbats|........|
|000011e0| 00 00 10 86 00 00 00 c2 | 00 38 f6 ac 0a a8 00 00 |........|.8......|
|000011f0| 00 1c 00 c2 00 06 50 49 | 4e 46 00 00 00 3a 44 53 |......PI|NF...:DS|
|00001200| 54 41 00 00 00 46 53 4f | 42 4a 00 01 00 52 53 48 |TA...FSO|BJ...RSH|
|00001210| 41 50 00 01 00 6a 43 45 | 58 54 00 00 00 82 53 4c |AP...jCE|XT....SL|
|00001220| 53 54 00 00 00 8e 46 54 | 42 4c 00 00 00 9a 00 80 |ST....FT|BL......|
|00001230| ff ff 00 00 00 00 00 00 | 00 00 00 80 ff ff 00 00 |........|........|
|00001240| 00 7c 00 00 00 00 4d a5 | ff ff 20 00 00 aa 00 00 |.|....M.|.. .....|
|00001250| 00 00 41 11 ff ff 20 00 | 07 f8 00 00 00 00 4d a5 |..A... .|......M.|
|00001260| ff ff 20 00 02 b2 00 00 | 00 00 41 11 ff ff 20 00 |.. .....|..A... .|
|00001270| 0a 00 00 00 00 00 41 11 | ff ff 20 00 10 22 00 00 |......A.|.. .."..|
|00001280| 00 00 00 80 ff ff 00 00 | 10 3a 00 00 00 00 00 80 |........|.:......|
|00001290| ff ff 00 00 10 42 00 00 | 00 00                   |.....B..|..      |
+--------+-------------------------+-------------------------+--------+--------+